-- @author lixiyong01
-- @date 2021.11.11
-- 无人认领表处理结果

CREATE TABLE `hdp_lbg_supin_zplisting.zp_app_comm_governance_table_no_owner_rename`(
  `db_name` string COMMENT '数据库名',
  `table_name` string COMMENT '表名',
  `user_name` string COMMENT '表负责人',
  `is_claim` int COMMENT '是否被认领：1-已认领，0-未认领',
  `hot` int COMMENT '表热度',
  `filesize` string COMMENT '表大小',
  `create_time` string COMMENT '表创建时间'
) COMMENT '未认领已删除表'
PARTITIONED BY (`dt` string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ',' LINES TERMINATED BY '\n'
STORED AS TEXTFILE

